MFG SAP S/4 HANA Products System API - Implementation Template

2.6.x
(0 reviews)

Data mappings

This document provides information generated from the DataWeave scripts included in the project, such as function definitions, variable definitions, and data mapping tables.

ModuleDescription
createProductRequestMaps the CIM request to create product data in SAP S/4HANA
getProductResponseMaps the SAP S/4HANA product to CIM response
createPricingReqMaps the CIM request to create product pricing data in SAP S/4HANA
updateProductsRequestMaps the CIM to SAP S/4HANA update product description
updateProductdescriptionMaps the CIM to SAP S/4HANA update product description
updatePricingReqMaps the CIM to SAP S/4HANA update product pricing

createProductRequest

Maps the CIM request to create product data in SAP S/4HANA

Source: ./src/main/resources/dwl/createProductRequest.dwl

Mapping Tables

Maps CIM Product format to HANA product request mapping

HANACIMDescription
ProductGroupproductLevelIf the Product Level is product "L001" else "L005"
ProductGroupproductLevelIf the Product Level is product "L001" else "L005"
Productidproduct id
IndustryStandardNamedescriptionproduct description
idProductproduct id
ProductStandardIDProductTypeproduct type
to_Valuation.Productidproduct Id
to_Valuation.StandardPricemSRPAmountstandard price
to_Valuation.PrevInvtryPriceInCoCodeCrcymSRPAmountproduct price
to_Valuation.PriceUnitQtyquantityThe quantity of the product default 1
to_Valuation.IsMarkedForDeletionfalsedefault to false
to_Valuation.MovingAveragePricemSRPAmountproduct mSRPAmount
to_Valuation.PlannedPricemSRPAmountThe product planned Price
to_Valuation.CurrencyUSDdefault to USD
to_Valuation.PriceDeterminationControl""The product PriceDeterminationControl default to ""
to_Valuation.ValuationType""The product ValuationType default to ""
to_Valuation.InventoryValuationProcedure""The product InventoryValuationProcedure default to ""
to_Valuation.ProdCostEstNumber""The product ProdCostEstNumber default to ""
to_Valuation.ProductOriginType""The ProductOriginType default to ""
to_Valuation.IsProducedInhousefalseThe product IsProducedInhouse default to false
to_Valuation.PlannedPrice1InCoCodeCrcymSRPAmountThe Product PlannedPrice Currency
to_Valuation.TaxBasedPricesPriceUnitQty0The product TaxBasedPricesPriceUnitQty default to 0
to_Valuation.ValuationArea1710The product ValuationArea default to 1710
to_Valuation.BaseUnit""The product BaseUnit default to ""
to_Valuation. ValuationClass3100The product class default to 3100
to_Valuation.ValuationCategory""The ValuationCategory default to ""
BrandbrandThe product Brand
ProductTypeMATThe ProductType default to MAT
to_Description.LanguageENLanguage default to EN(English)
to_Description.Productidproduct id
to_Description.ProductDescriptionnameproduct name
to_SalesDelivery.productIdproductId
to_SalesDelivery.ProductDescriptionchnl10The product description channel default to 10
to_SalesDelivery.ProductSalesOrg1710Sales org is default to 1710
to_SalesDelivery.ItemCategoryGroupNORMdefault to NORM
to_SalesDelivery.to_SalesTax.productIdproductId
to_SalesDelivery.to_SalesTax.CountryUSdefault to US
to_SalesDelivery.to_SalesTax.TaxCategoryUTXJdefault to UTXJ
to_SalesDelivery.to_SalesTax.TaxClassification1default to 1
to_Plant.productIdproductId
to_Plant.Plant1710default to 1710
to_Plant.PurchasingGroup002default to 002
to_Plant.PeriodTypeMdefault to M
to_Plant.ProfitCenterYB700default to YB700
to_Plant.MaintenanceStatusNameBEVDLPdefault to BEVDLP
to_Plant.IsMarkedForDeletionfalsedefault to False
to_Plant.ProcurementTypeFdefault to F
to_Plant.MRPTypeNDdefault to ND
to_Plant.MRPResponsible001default to 001
to_Plant.to_PlantSales.ProductIdproductId
to_Plant.to_PlantSales.Plant1710default to 1710
to_Plant.to_PlantSales.LoadingGroup0001default to 0001
to_Plant.to_PlantSales.AvailabilityCheckTypeSPdefault to SP
GrossWeightcontainerSizeproduct grossWeight
NetWeight0default to 0
SizeOrDimensionTextsizesize of the product
CrossPlantConfigurableProduct""default to ""
ProductManufacturerNumber""default to ""
MaximumPackagingLength0.000default to 0.000
HasVariableTareWeightfalsedefault to false
ANPCode""default to ""
WeightUnitcontainerSizeUnitcontainerSize
ProdNoInGenProdInPrepackProd""default to ""
IsMarkedForDeletionfalsedefault to False
CompetitorID""default to ""
QualityInspectionGroup""default to ""
IsBatchManagementRequiredFalsedefault to false
IsRelevantForHzdsSubstancesFalsedefault to False
Division00default to 00
IndustrySectorMdefault to m
ProductIsConfigurableFalsedefault to false
QltyMgmtInProcmtIsActivfalsedefault to False
MaximumPackagingHeight0.000The maximum product height default to 0.000
BaseUnitcontainerTypeThe product container Type
YY1_SME_UnvProductId_PRDexternalIdproduct externalId

(back to top)

getProductResponse

Maps the SAP S/4HANA product to CIM response

Source: ./src/main/resources/dwl/getProductResponse.dwl

Mapping Tables

get Products response mapping.

CIMHANADescription of source field
nameIndustryStandardNameproduct name
longDescriptionProductDescriptionproduct item description
idProductproduct id
productStatusCrossPlantStatusproduct cross plant status
descriptionto_Descriptionproduct description
productSKUProductTypeproduct type
typeProductTypeproduct type
productCodeProductproduct code
productShortCodeSet as ""product short code
manufacturerNameIndustryStandardNameproduct manufacturer name
primaryProductCategoryProductGroupproduct primary category
masterProductProductGroupproduct master product
brandBrandproduct brand
containerSizeGrossWeightproduct container size
containerSizeUnitWeightUnitproduct container size unit
containerTypeBaseUnitproduct container type
manufacturerIndustryStandardNameproduct manufacturer
weightGrossWeightproduct weight
heightSizeOrDimensionTexproduct height
sizeSizeOrDimensionTextproduct size
productCategory.idnullproductCategory default to null
productCategory.nameHierarchyNodeproduct primary category name
productCategory.activeFromDateProdHierarchyValidityStartDateproduct category activeFromDate
productCategory.activeToDateProdHierarchyValidityEndDateproduct category activeToDate
parentCategoryproductLevelproduct level
productCatalog.idnullcatalog id default to null
productCatalog.nameProdUnivHierarchyproduct catalog name
productCatalog.activeFromDateProdHierarchyValidityStartDateproduct catalog active from date
productCatalog.activeToDateProdHierarchyValidityEndDateproduct catalog active to date
priceBookEntry.idnullprice book entry default to null
priceBookEntry.minRequiredQuantitypricingResponse)[0].to_SlsPrcgConditionRecord.ConditionQuantityproduct pricing response
priceBookEntry.maxRequiredOrderValue0price book entry default to 0
priceBookEntry.unitListPricepricingResponse)[0].to_SlsPrcgConditionRecord.ConditionRateValueproduct pricing response
priceBookEntry.isActivetruepriceBookEntry default to true
auditInfo.isDeletedfalseauditInfo default to false
auditInfo.createdByCreatedByUserproduct created by
auditInfo.updatedByLastChangedByUserproduct updated by
auditInfo.updatedDateLastChangeDateTimeproduct updated date
auditInfo.createdDateCreationDateproduct creation date
externalIds.externalIdTypeMDMdefault to MDM
externalIds.externalIdYY1_SME_UnvProductId_PRDexternal id
externalIds.idnullexternalIds default to null
externalIds.statusVALIDexternalIds default to valid
externalIds.statusLastChangedOnnow()externalIds default to now()

(back to top)

createPricingReq

Maps the CIM request to create product pricing data in SAP S/4HANA

Source: ./src/main/resources/dwl/createPricingReq.dwl

Mapping Tables

create Pricing request mapping.

CIMHana Source fieldDescription of source field
NAConditionTabledefault to '304'
NAConditionTypedefault to 'PPR0'
priceBookEntry.unitListPriceConditionRateValueproduct unit price
NAConditionRateValueUnitproduct pricing currency
NAto_SlsPrcgCndnRecdValidity.ConditionValidityEndDatedefault to "9999-12-31T00:00:00"
NAto_SlsPrcgCndnRecdValidity.ConditionValidityStartDatedefault to current timestamp
idto_SlsPrcgCndnRecdValidity.Materialproduct Id
NAto_SlsPrcgCndnRecdValidity.SalesOrganizationdefault to "1710"
NAto_SlsPrcgCndnRecdValidity.DistributionChanneldefault to "10"

(back to top)

updateProductsRequest

Maps the CIM to SAP S/4HANA update product description

Source: ./src/main/resources/dwl/updateProductsRequest.dwl

Mapping Tables

Maps CIM Product format to HANA Custom product request mapping

HANACIMDescription
ProductproductIdproductId
IndustryStandardNamenameproduct name
ProductTypeMATProduct type default to MAT
GrossWeightcontainerSizeProduct Container Size
NetWeightnetWeightproduct net weight
CrossPlantConfigurableProduct""default to ""
ProductManufacturerNumber""default to ""
MaximumPackagingLength0.000default to 0.000
HasVariableTareWeightfalsedefault to false
ANPCode""default to ""
WeightUnitcontainerSizeUnitProduct container size unit
ProdNoInGenProdInPrepackProd""default to ""
CompetitorID""default to false
QualityInspectionGroup""default to ""
IsBatchManagementRequiredfalsedefault to false
IsRelevantForHzdsSubstancesfalsedefault to false
Division00default to 00
IndustrySectorMfalsedefault to M
ProductIsConfigurablefalsedefault to false
QltyMgmtInProcmtIsActivefalsedefault to false
MaximumPackagingHeightfalsedefault to false
BaseUnitcontainerTypeProduct container type
YY1_SME_UnvProductId_PRDexternalIdsproduct external id

(back to top)

updateProductdescription

Maps the CIM to SAP S/4HANA update product description

Source: ./src/main/resources/dwl/updateProductdescription.dwl

Mapping Tables

Maps CIM Product format to HANA Custom product request mapping

HANACIMDescription
Language"EN"default to 'EN'
ProductproductIdproduct Id
ProductDescriptionnamedescription of Product

(back to top)

updatePricingReq

Maps the CIM to SAP S/4HANA update product pricing

Source: ./src/main/resources/dwl/updatePricingReq.dwl

Mapping Tables

create Pricing request mapping.

cimHana Source fieldDescription of source field
ConditionRecordConditionRecordpricing condition
priceBookEntry.unitListPriceConditionRateValueproduct unit price
to_SlsPrcgConditionRecord.ConditionRateValueUnitConditionRateValueUnitproduct rate value unit

(back to top)

Reviews

TypeTemplate
OrganizationMulesoft Inc.
Published by
MuleSoft Solutions
Published onOct 27, 2023

Asset versions for 2.6.x

Version
2.6.1
2.6.0